package com.sun.temp.mapper.mapper1;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sun.temp.bean.Material;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
//@DS("db1")
public interface MaterialDao extends BaseMapper<Material> {
//    @Select("select * from t_user where name = #{name}")
//    @ResultType(User.class)
//    List<User> getUserListByName(@Param("name") String name);
//
//    @Select("select * from t_user where id = #{id}")
//    @ResultType(User.class)
//    User getUserById(@Param("id") String id);
//
//    @Select("select name from t_user where id = #{id}")
//    String getUserNameById(@Param("id") String id);
    List<Material> queryMaterial();

    List<Material>  queryMaterialByDate(String dateStr);

    List<Material> queryMaterialByGradeAndBatch(String grade,String batch);

    List<Material> queryMaterialByStatus(Integer status);

    List<Material> queryBatchByTaskId(Integer taskId);

    List<Material> queryBatchSuccessByTaskId(Integer taskId);

    List<Material> queryMaterialToday();

}
